Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	55292
Missing cells	3262
Missing cells (%)	0.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	6.0 MiB
Average record size in memory	113.0 B

Variable types

Categorical	5
Numeric	9
Boolean	1

Alerts

`User Comments Added` has constant value "0"	Constant
`Video Title` has a high cardinality: 223 distinct values	High cardinality
`External Video ID` has a high cardinality: 223 distinct values	High cardinality
`Thumbnail link` has a high cardinality: 223 distinct values	High cardinality
`Country Code` has a high cardinality: 233 distinct values	High cardinality
`Video Length` is highly correlated with `Average View Percentage`	High correlation
`Views` is highly correlated with `Video Likes Added`	High correlation
`Video Likes Added` is highly correlated with `Views`	High correlation
`Average View Percentage` is highly correlated with `Video Length`	High correlation
`Views` is highly correlated with `Video Likes Added` and 2 other fields	High correlation
`Video Likes Added` is highly correlated with `Views` and 2 other fields	High correlation
`Video Dislikes Added` is highly correlated with `Views` and 2 other fields	High correlation
`Video Likes Removed` is highly correlated with `Views` and 2 other fields	High correlation
`User Subscriptions Added` is highly correlated with `User Subscriptions Removed`	High correlation
`User Subscriptions Removed` is highly correlated with `User Subscriptions Added`	High correlation
`Views` is highly correlated with `Video Likes Added`	High correlation
`Video Likes Added` is highly correlated with `Views`	High correlation
`Is Subscribed` is highly correlated with `User Comments Added`	High correlation
`User Comments Added` is highly correlated with `Is Subscribed`	High correlation
`Views` is highly correlated with `Video Likes Added` and 2 other fields	High correlation
`Video Likes Added` is highly correlated with `Views` and 4 other fields	High correlation
`Video Dislikes Added` is highly correlated with `Views` and 2 other fields	High correlation
`Video Likes Removed` is highly correlated with `Views` and 3 other fields	High correlation
`User Subscriptions Added` is highly correlated with `Video Likes Added` and 2 other fields	High correlation
`User Subscriptions Removed` is highly correlated with `Video Likes Added` and 1 other fields	High correlation
`Average View Percentage` has 1438 (2.6%) missing values	Missing
`Average Watch Time` has 1438 (2.6%) missing values	Missing
`Views` is highly skewed (γ1 = 119.5300004)	Skewed
`Video Likes Added` is highly skewed (γ1 = 99.02482423)	Skewed
`Video Dislikes Added` is highly skewed (γ1 = 105.6523379)	Skewed
`Video Likes Removed` is highly skewed (γ1 = 83.20521254)	Skewed
`User Subscriptions Added` is highly skewed (γ1 = 117.6209316)	Skewed
`User Subscriptions Removed` is highly skewed (γ1 = 84.02905204)	Skewed
`Views` has 1438 (2.6%) zeros	Zeros
`Video Likes Added` has 34576 (62.5%) zeros	Zeros
`Video Dislikes Added` has 53135 (96.1%) zeros	Zeros
`Video Likes Removed` has 52313 (94.6%) zeros	Zeros
`User Subscriptions Added` has 46830 (84.7%) zeros	Zeros
`User Subscriptions Removed` has 53796 (97.3%) zeros	Zeros

Reproduction

Analysis started	2022-04-04 00:45:30.667774
Analysis finished	2022-04-04 00:45:49.243577
Duration	18.58 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

Video Title
Categorical

HIGH CARDINALITY

Distinct	223
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	432.1 KiB

How I Would Learn Data Science (If I Had to Start Over)	428
The Best Free Data Science Courses Nobody is Talking About	405
3 Proven Data Science Projects for Beginners (Kaggle)	390
How I Learned Data Science	384
How I Would Learn Data Science in 2021 (What Has Changed?)	380
Other values (218)	53305

Length

Max length	100
Median length	55
Mean length	54.33408088
Min length	21

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	🌶 Hot Topics in Tech: Data Science Explained #SHORTS
2nd row	🌶 Hot Topics in Tech: Data Science Explained #SHORTS
3rd row	🌶 Hot Topics in Tech: Data Science Explained #SHORTS
4th row	🌶 Hot Topics in Tech: Data Science Explained #SHORTS
5th row	🌶 Hot Topics in Tech: Data Science Explained #SHORTS

Common Values

Value	Count	Frequency (%)
How I Would Learn Data Science (If I Had to Start Over)	428	0.8%
The Best Free Data Science Courses Nobody is Talking About	405	0.7%
3 Proven Data Science Projects for Beginners (Kaggle)	390	0.7%
How I Learned Data Science	384	0.7%
How I Would Learn Data Science in 2021 (What Has Changed?)	380	0.7%
Why I Quit Data Science	377	0.7%
Beginner Kaggle Data Science Project Walk-Through (Titanic)	376	0.7%
Why You Probably Won't Become a Data Scientist	375	0.7%
How I Would Learn Data Science in 2022 (If I Had to Start Over)	373	0.7%
3 Reasons You Should NOT Become a Data Scientist	369	0.7%
Other values (213)	51435	93.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
data	49359	9.6%
science	37383	7.2%
	20756	4.0%
a	12450	2.4%
to	11723	2.3%
the	11399	2.2%
how	10378	2.0%
your	7708	1.5%
i	7393	1.4%
projects	7174	1.4%
Other values (610)	340682	66.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

External Video ID
Categorical

HIGH CARDINALITY

Distinct	223
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	432.1 KiB

4OZip0cgOho	428
Ip50cXvpWY4	405
8igH8qZafpo	390
n3vw0M5RrPU	384
41Clrh6nv1s	380
Other values (218)	53305

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	OtqQYqRNDGI
2nd row	OtqQYqRNDGI
3rd row	OtqQYqRNDGI
4th row	OtqQYqRNDGI
5th row	OtqQYqRNDGI

Common Values

Value	Count	Frequency (%)
4OZip0cgOho	428	0.8%
Ip50cXvpWY4	405	0.7%
8igH8qZafpo	390	0.7%
n3vw0M5RrPU	384	0.7%
41Clrh6nv1s	380	0.7%
SVtRsDhHlDk	377	0.7%
I3FBJdiExcg	376	0.7%
sHRq-LshG3U	375	0.7%
xpIFS6jZbe8	373	0.7%
m5pwx3hgtzM	369	0.7%
Other values (213)	51435	93.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
4ozip0cgoho	428	0.8%
ip50cxvpwy4	405	0.7%
8igh8qzafpo	390	0.7%
n3vw0m5rrpu	384	0.7%
41clrh6nv1s	380	0.7%
svtrsdhhldk	377	0.7%
i3fbjdiexcg	376	0.7%
shrq-lshg3u	375	0.7%
xpifs6jzbe8	373	0.7%
m5pwx3hgtzm	369	0.7%
Other values (213)	51435	93.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Video Length
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	202
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	896.6780728

Minimum	47
Maximum	5029
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.1 KiB

Quantile statistics

Minimum	47
5-th percentile	60
Q1	375
median	545
Q3	934
95-th percentile	2968
Maximum	5029
Range	4982
Interquartile range (IQR)	559

Descriptive statistics

Standard deviation	927.3808005
Coefficient of variation (CV)	1.034240525
Kurtosis	4.531092553
Mean	896.6780728
Median Absolute Deviation (MAD)	214
Skewness	2.169722905
Sum	49579124
Variance	860035.1492
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59	1248	2.3%
467	865	1.6%
375	836	1.5%
495	807	1.5%
549	733	1.3%
291	717	1.3%
392	623	1.1%
334	611	1.1%
378	555	1.0%
355	552	1.0%
Other values (192)	47745	86.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
47	230	0.4%
51	133	0.2%
53	196	0.4%
55	166	0.3%
56	491	0.9%
57	191	0.3%
59	1248	2.3%
60	265	0.5%
114	78	0.1%
128	244	0.4%

Value	Count	Frequency (%)
5029	183	0.3%
5005	169	0.3%
4518	212	0.4%
4119	327	0.6%
4112	297	0.5%
3735	177	0.3%
3706	207	0.4%
3659	242	0.4%
3493	207	0.4%
3413	174	0.3%

Thumbnail link
Categorical

HIGH CARDINALITY

Distinct	223
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	432.1 KiB

https://i.ytimg.com/vi/4OZip0cgOho/hqdefault.jpg	428
https://i.ytimg.com/vi/Ip50cXvpWY4/hqdefault.jpg	405
https://i.ytimg.com/vi/8igH8qZafpo/hqdefault.jpg	390
https://i.ytimg.com/vi/n3vw0M5RrPU/hqdefault.jpg	384
https://i.ytimg.com/vi/41Clrh6nv1s/hqdefault.jpg	380
Other values (218)	53305

Length

Max length	48
Median length	48
Mean length	48
Min length	48

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg
2nd row	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg
3rd row	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg
4th row	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg
5th row	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg

Common Values

Value	Count	Frequency (%)
https://i.ytimg.com/vi/4OZip0cgOho/hqdefault.jpg	428	0.8%
https://i.ytimg.com/vi/Ip50cXvpWY4/hqdefault.jpg	405	0.7%
https://i.ytimg.com/vi/8igH8qZafpo/hqdefault.jpg	390	0.7%
https://i.ytimg.com/vi/n3vw0M5RrPU/hqdefault.jpg	384	0.7%
https://i.ytimg.com/vi/41Clrh6nv1s/hqdefault.jpg	380	0.7%
https://i.ytimg.com/vi/SVtRsDhHlDk/hqdefault.jpg	377	0.7%
https://i.ytimg.com/vi/I3FBJdiExcg/hqdefault.jpg	376	0.7%
https://i.ytimg.com/vi/sHRq-LshG3U/hqdefault.jpg	375	0.7%
https://i.ytimg.com/vi/xpIFS6jZbe8/hqdefault.jpg	373	0.7%
https://i.ytimg.com/vi/m5pwx3hgtzM/hqdefault.jpg	369	0.7%
Other values (213)	51435	93.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
https://i.ytimg.com/vi/4ozip0cgoho/hqdefault.jpg	428	0.8%
https://i.ytimg.com/vi/ip50cxvpwy4/hqdefault.jpg	405	0.7%
https://i.ytimg.com/vi/8igh8qzafpo/hqdefault.jpg	390	0.7%
https://i.ytimg.com/vi/n3vw0m5rrpu/hqdefault.jpg	384	0.7%
https://i.ytimg.com/vi/41clrh6nv1s/hqdefault.jpg	380	0.7%
https://i.ytimg.com/vi/svtrsdhhldk/hqdefault.jpg	377	0.7%
https://i.ytimg.com/vi/i3fbjdiexcg/hqdefault.jpg	376	0.7%
https://i.ytimg.com/vi/shrq-lshg3u/hqdefault.jpg	375	0.7%
https://i.ytimg.com/vi/xpifs6jzbe8/hqdefault.jpg	373	0.7%
https://i.ytimg.com/vi/m5pwx3hgtzm/hqdefault.jpg	369	0.7%
Other values (213)	51435	93.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Country Code
Categorical

HIGH CARDINALITY

Distinct	233
Distinct (%)	0.4%
Missing	386
Missing (%)	0.7%
Memory size	432.1 KiB

NL	445
AU	445
US	445
DE	445
GB	445
Other values (228)	52681

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	HK
2nd row	ME
3rd row	RW
4th row	US
5th row	DE

Common Values

Value	Count	Frequency (%)
NL	445	0.8%
AU	445	0.8%
US	445	0.8%
DE	445	0.8%
GB	445	0.8%
IN	445	0.8%
MY	444	0.8%
FR	444	0.8%
VN	444	0.8%
CA	444	0.8%
Other values (223)	50460	91.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nl	445	0.8%
us	445	0.8%
de	445	0.8%
gb	445	0.8%
in	445	0.8%
au	445	0.8%
my	444	0.8%
fr	444	0.8%
vn	444	0.8%
ca	444	0.8%
Other values (223)	50460	91.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Is Subscribed
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	54.1 KiB

False	28588
True	26704

Common Values
Chart

Value	Count	Frequency (%)
False	28588	51.7%
True	26704	48.3%

Views
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	1558
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	100.5731571

Minimum	0
Maximum	285593
Zeros	1438
Zeros (%)	2.6%
Negative	0
Negative (%)	0.0%
Memory size	432.1 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	7
Q3	27
95-th percentile	241.45
Maximum	285593
Range	285593
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	1704.966002
Coefficient of variation (CV)	16.9524956
Kurtosis	17956.63941
Mean	100.5731571
Median Absolute Deviation (MAD)	6
Skewness	119.5300004
Sum	5560891
Variance	2906909.069
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	9837	17.8%
2	5502	10.0%
3	3783	6.8%
4	2760	5.0%
5	2104	3.8%
6	1834	3.3%
7	1582	2.9%
0	1438	2.6%
8	1306	2.4%
9	1160	2.1%
Other values (1548)	23986	43.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1438	2.6%
1	9837	17.8%
2	5502	10.0%
3	3783	6.8%
4	2760	5.0%
5	2104	3.8%
6	1834	3.3%
7	1582	2.9%
8	1306	2.4%
9	1160	2.1%

Value	Count	Frequency (%)
285593	1	< 0.1%
203055	1	< 0.1%
70240	1	< 0.1%
49982	1	< 0.1%
44835	1	< 0.1%
43314	1	< 0.1%
42422	1	< 0.1%
35950	1	< 0.1%
33098	1	< 0.1%
27263	1	< 0.1%

Video Likes Added
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	317
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.239311293

Minimum	0
Maximum	9165
Zeros	34576
Zeros (%)	62.5%
Negative	0
Negative (%)	0.0%
Memory size	432.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	11
Maximum	9165
Range	9165
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	65.29145094
Coefficient of variation (CV)	15.40142878
Kurtosis	12536.66906
Mean	4.239311293
Median Absolute Deviation (MAD)	0
Skewness	99.02482423
Sum	234400
Variance	4262.973566
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	34576	62.5%
1	8632	15.6%
2	3341	6.0%
3	1837	3.3%
4	1172	2.1%
5	852	1.5%
6	658	1.2%
7	509	0.9%
8	362	0.7%
9	285	0.5%
Other values (307)	3068	5.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34576	62.5%
1	8632	15.6%
2	3341	6.0%
3	1837	3.3%
4	1172	2.1%
5	852	1.5%
6	658	1.2%
7	509	0.9%
8	362	0.7%
9	285	0.5%

Value	Count	Frequency (%)
9165	1	< 0.1%
8442	1	< 0.1%
4386	1	< 0.1%
2629	1	< 0.1%
1917	1	< 0.1%
1776	1	< 0.1%
1723	1	< 0.1%
1680	1	< 0.1%
1589	1	< 0.1%
1481	1	< 0.1%

Video Dislikes Added
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	41
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1060551255

Minimum	0
Maximum	399
Zeros	53135
Zeros (%)	96.1%
Negative	0
Negative (%)	0.0%
Memory size	432.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	399
Range	399
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.507351484
Coefficient of variation (CV)	23.64196423
Kurtosis	14023.29063
Mean	0.1060551255
Median Absolute Deviation (MAD)	0
Skewness	105.6523379
Sum	5864
Variance	6.286811466
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
0	53135	96.1%
1	1496	2.7%
2	307	0.6%
3	126	0.2%
4	50	0.1%
5	34	0.1%
6	27	< 0.1%
7	17	< 0.1%
10	13	< 0.1%
8	12	< 0.1%
Other values (31)	75	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	53135	96.1%
1	1496	2.7%
2	307	0.6%
3	126	0.2%
4	50	0.1%
5	34	0.1%
6	27	< 0.1%
7	17	< 0.1%
8	12	< 0.1%
9	9	< 0.1%

Value	Count	Frequency (%)
399	1	< 0.1%
230	1	< 0.1%
174	1	< 0.1%
170	1	< 0.1%
147	1	< 0.1%
131	1	< 0.1%
54	1	< 0.1%
51	1	< 0.1%
39	1	< 0.1%
38	2	< 0.1%

Video Likes Removed
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	53
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.175576937

Minimum	0
Maximum	436
Zeros	52313
Zeros (%)	94.6%
Negative	0
Negative (%)	0.0%
Memory size	432.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	436
Range	436
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.601170733
Coefficient of variation (CV)	20.51049981
Kurtosis	8239.726658
Mean	0.175576937
Median Absolute Deviation (MAD)	0
Skewness	83.20521254
Sum	9708
Variance	12.96843065
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	52313	94.6%
1	1891	3.4%
2	485	0.9%
3	185	0.3%
4	97	0.2%
5	64	0.1%
6	41	0.1%
7	34	0.1%
9	24	< 0.1%
8	23	< 0.1%
Other values (43)	135	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	52313	94.6%
1	1891	3.4%
2	485	0.9%
3	185	0.3%
4	97	0.2%
5	64	0.1%
6	41	0.1%
7	34	0.1%
8	23	< 0.1%
9	24	< 0.1%

Value	Count	Frequency (%)
436	1	< 0.1%
356	1	< 0.1%
327	1	< 0.1%
308	1	< 0.1%
237	1	< 0.1%
149	1	< 0.1%
121	1	< 0.1%
102	1	< 0.1%
77	1	< 0.1%
76	1	< 0.1%

User Subscriptions Added
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	239
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.365278883

Minimum	0
Maximum	9599
Zeros	46830
Zeros (%)	84.7%
Negative	0
Negative (%)	0.0%
Memory size	432.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3
Maximum	9599
Range	9599
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	65.88953882
Coefficient of variation (CV)	27.85698519
Kurtosis	16418.41419
Mean	2.365278883
Median Absolute Deviation (MAD)	0
Skewness	117.6209316
Sum	130781
Variance	4341.431326
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	46830	84.7%
1	3697	6.7%
2	1311	2.4%
3	707	1.3%
4	428	0.8%
5	297	0.5%
6	241	0.4%
7	169	0.3%
8	132	0.2%
9	118	0.2%
Other values (229)	1362	2.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	46830	84.7%
1	3697	6.7%
2	1311	2.4%
3	707	1.3%
4	428	0.8%
5	297	0.5%
6	241	0.4%
7	169	0.3%
8	132	0.2%
9	118	0.2%

Value	Count	Frequency (%)
9599	1	< 0.1%
9560	1	< 0.1%
3760	1	< 0.1%
2615	1	< 0.1%
1754	1	< 0.1%
1563	1	< 0.1%
1505	1	< 0.1%
1458	1	< 0.1%
1246	1	< 0.1%
1197	1	< 0.1%

User Subscriptions Removed
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.05338927874

Minimum	0
Maximum	103
Zeros	53796
Zeros (%)	97.3%
Negative	0
Negative (%)	0.0%
Memory size	432.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	103
Range	103
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7669446756
Coefficient of variation (CV)	14.36514397
Kurtosis	10080.24578
Mean	0.05338927874
Median Absolute Deviation (MAD)	0
Skewness	84.02905204
Sum	2952
Variance	0.5882041354
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
0	53796	97.3%
1	1048	1.9%
2	210	0.4%
3	83	0.2%
4	61	0.1%
5	27	< 0.1%
6	23	< 0.1%
7	8	< 0.1%
9	5	< 0.1%
11	4	< 0.1%
Other values (15)	27	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	53796	97.3%
1	1048	1.9%
2	210	0.4%
3	83	0.2%
4	61	0.1%
5	27	< 0.1%
6	23	< 0.1%
7	8	< 0.1%
8	3	< 0.1%
9	5	< 0.1%

Value	Count	Frequency (%)
103	1	< 0.1%
93	1	< 0.1%
46	1	< 0.1%
22	1	< 0.1%
21	1	< 0.1%
19	1	< 0.1%
18	1	< 0.1%
17	1	< 0.1%
16	3	< 0.1%
15	1	< 0.1%

Average View Percentage
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	53339
Distinct (%)	99.0%
Missing	1438
Missing (%)	2.6%
Infinite	0
Infinite (%)	0.0%
Mean	0.3478206381

Minimum	0
Maximum	4.96779661
Zeros	50
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	432.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.01261269551
Q1	0.1459483144
median	0.3209825692
Q3	0.4861525058
95-th percentile	0.8828756256
Maximum	4.96779661
Range	4.96779661
Interquartile range (IQR)	0.3402041914

Descriptive statistics

Standard deviation	0.2597338836
Coefficient of variation (CV)	0.7467466136
Kurtosis	5.793724931
Mean	0.3478206381
Median Absolute Deviation (MAD)	0.1702192838
Skewness	1.238104983
Sum	18731.53264
Variance	0.0674616903
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	108	0.2%
0	50	0.1%
0.9996607143	10	< 0.1%
0.9931090909	8	< 0.1%
0.9829803922	7	< 0.1%
0.9969661017	7	< 0.1%
0.9995510511	6	< 0.1%
0.9831568627	6	< 0.1%
0.9994341085	6	< 0.1%
0.9856792453	6	< 0.1%
Other values (53329)	53640	97.0%
(Missing)	1438	2.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	50	0.1%
8.275261324 × 10^-6	1	< 0.1%
2.433528616 × 10^-5	1	< 0.1%
4.403669725 × 10^-5	1	< 0.1%
6.88712763 × 10^-5	1	< 0.1%
9.255178493 × 10^-5	1	< 0.1%
9.718172983 × 10^-5	1	< 0.1%
0.0001101291638	1	< 0.1%
0.0001131221719	1	< 0.1%
0.0001221406992	1	< 0.1%

Value	Count	Frequency (%)
4.96779661	1	< 0.1%
4.618173448	1	< 0.1%
3.586967797	1	< 0.1%
3.3365	1	< 0.1%
2.940123457	1	< 0.1%
2.89787234	1	< 0.1%
2.827118644	1	< 0.1%
2.598663477	1	< 0.1%
2.496910714	1	< 0.1%
2.465447368	1	< 0.1%

Average Watch Time
Real number (ℝ_≥0)

MISSING

Distinct	50508
Distinct (%)	93.8%
Missing	1438
Missing (%)	2.6%
Infinite	0
Infinite (%)	0.0%
Mean	205.2971559

Minimum	0
Maximum	5027.66
Zeros	50
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	432.1 KiB

Quantile statistics

Minimum	0
5-th percentile	11.50155
Q1	85.44289063
median	170.139725
Q3	259.4499583
95-th percentile	520.835
Maximum	5027.66
Range	5027.66
Interquartile range (IQR)	174.0070677

Descriptive statistics

Standard deviation	206.5421061
Coefficient of variation (CV)	1.006064137
Kurtosis	53.25812607
Mean	205.2971559
Median Absolute Deviation (MAD)	87.09354368
Skewness	4.991217213
Sum	11056073.04
Variance	42659.6416
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	51	0.1%
0	50	0.1%
12	33	0.1%
4	33	0.1%
2	32	0.1%
11	32	0.1%
59	32	0.1%
0.9	31	0.1%
10.9	31	0.1%
3	31	0.1%
Other values (50498)	53498	96.8%
(Missing)	1438	2.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	50	0.1%
0.019	1	< 0.1%
0.024	1	< 0.1%
0.054	1	< 0.1%
0.065	1	< 0.1%
0.1	7	< 0.1%
0.109	1	< 0.1%
0.113	1	< 0.1%
0.147	1	< 0.1%
0.162	1	< 0.1%

Value	Count	Frequency (%)
5027.66	1	< 0.1%
4259.5	1	< 0.1%
4118.721	1	< 0.1%
3878.559	1	< 0.1%
3840.17	1	< 0.1%
3712.5025	1	< 0.1%
3708.933	1	< 0.1%
3705.327	1	< 0.1%
3492.461	1	< 0.1%
3492.312	1	< 0.1%

User Comments Added
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	432.1 KiB

0	55292

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	55292	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	55292	100.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Video Title	External Video ID	Video Length	Thumbnail link	Country Code	Is Subscribed	Views	Video Likes Added	Video Dislikes Added	Video Likes Removed	User Subscriptions Added	User Subscriptions Removed	Average View Percentage	Average Watch Time
0	🌶 Hot Topics in Tech: Data Science Explained #SHORTS	OtqQYqRNDGI	59	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg	HK	True	23	1	0	0	2	0	0.671870	39.640348
1	🌶 Hot Topics in Tech: Data Science Explained #SHORTS	OtqQYqRNDGI	59	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg	ME	True	3	0	0	0	0	0	0.498870	29.433333
2	🌶 Hot Topics in Tech: Data Science Explained #SHORTS	OtqQYqRNDGI	59	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg	RW	True	2	0	0	0	0	0	0.681780	40.225000
3	🌶 Hot Topics in Tech: Data Science Explained #SHORTS	OtqQYqRNDGI	59	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg	US	True	979	81	6	8	16	4	0.694854	40.996389
4	🌶 Hot Topics in Tech: Data Science Explained #SHORTS	OtqQYqRNDGI	59	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg	DE	False	75	3	0	1	0	0	0.661515	39.029373
5	🌶 Hot Topics in Tech: Data Science Explained #SHORTS	OtqQYqRNDGI	59	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg	ZZ	True	4	0	0	0	0	0	0.784517	46.286500
6	🌶 Hot Topics in Tech: Data Science Explained #SHORTS	OtqQYqRNDGI	59	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg	AR	True	30	3	0	0	0	0	0.671451	39.615600
7	🌶 Hot Topics in Tech: Data Science Explained #SHORTS	OtqQYqRNDGI	59	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg	BB	False	1	0	0	0	0	0	0.508475	30.000000
8	🌶 Hot Topics in Tech: Data Science Explained #SHORTS	OtqQYqRNDGI	59	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg	KZ	True	6	0	0	0	0	0	0.649322	38.310000
9	🌶 Hot Topics in Tech: Data Science Explained #SHORTS	OtqQYqRNDGI	59	https://i.ytimg.com/vi/OtqQYqRNDGI/hqdefault.jpg	NP	False	12	0	0	0	0	0	0.389364	22.972500

Last rows

	Video Title	External Video ID	Video Length	Thumbnail link	Country Code	Is Subscribed	Views	Video Likes Added	Average View Percentage	Average Watch Time
55282	#66DaysOfData - 3 Reasons to Start!	sICJ6a2wX5g	53	https://i.ytimg.com/vi/sICJ6a2wX5g/hqdefault.jpg	IQ	False	2	0	1.088774	57.705000
55283	#66DaysOfData - 3 Reasons to Start!	sICJ6a2wX5g	53	https://i.ytimg.com/vi/sICJ6a2wX5g/hqdefault.jpg	YE	True	2	0	0.549057	29.100000
55284	#66DaysOfData - 3 Reasons to Start!	sICJ6a2wX5g	53	https://i.ytimg.com/vi/sICJ6a2wX5g/hqdefault.jpg	IR	True	3	0	0.916774	48.589000
55285	#66DaysOfData - 3 Reasons to Start!	sICJ6a2wX5g	53	https://i.ytimg.com/vi/sICJ6a2wX5g/hqdefault.jpg	IT	True	36	2	0.554682	29.398139
55286	#66DaysOfData - 3 Reasons to Start!	sICJ6a2wX5g	53	https://i.ytimg.com/vi/sICJ6a2wX5g/hqdefault.jpg	IE	False	1	0	0.937283	49.676000
55287	#66DaysOfData - 3 Reasons to Start!	sICJ6a2wX5g	53	https://i.ytimg.com/vi/sICJ6a2wX5g/hqdefault.jpg	MM	False	1	0	0.622642	33.000000
55288	#66DaysOfData - 3 Reasons to Start!	sICJ6a2wX5g	53	https://i.ytimg.com/vi/sICJ6a2wX5g/hqdefault.jpg	SA	True	14	1	0.515569	27.325143
55289	#66DaysOfData - 3 Reasons to Start!	sICJ6a2wX5g	53	https://i.ytimg.com/vi/sICJ6a2wX5g/hqdefault.jpg	DZ	False	2	0	0.782075	41.450000
55290	#66DaysOfData - 3 Reasons to Start!	sICJ6a2wX5g	53	https://i.ytimg.com/vi/sICJ6a2wX5g/hqdefault.jpg	MX	False	11	0	0.636178	33.717455
55291	#66DaysOfData - 3 Reasons to Start!	sICJ6a2wX5g	53	https://i.ytimg.com/vi/sICJ6a2wX5g/hqdefault.jpg	SR	True	1	0	0.985679	52.241000

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows